{"statement":"select yr,  count(distinct[skew] lo_orderkey) from (select yr, case when (yr >= 1992 and yr <=1997) then (lo_orderkey%10) else lo_orderkey end as lo_orderkey from  (select year(lo_commitdate) as yr, murmur_hash3_32(lo_orderkey) as lo_orderkey, lo_extendedprice from lineorder_flat) t2 left outer join[shuffle]  (select column_0 as c0 from (values(1))t0)t1 on t1.c0 = t2.lo_extendedprice ) t group by yr;\n","table_meta":{"ssb_100g.lineorder_flat":"CREATE TABLE `lineorder_flat` (\n  `lo_orderdate` date NOT NULL COMMENT \"\",\n  `lo_orderkey` int(11) NOT NULL COMMENT \"\",\n  `lo_linenumber` tinyint(4) NOT NULL COMMENT \"\",\n  `lo_custkey` int(11) NOT NULL COMMENT \"\",\n  `lo_partkey` int(11) NOT NULL COMMENT \"\",\n  `lo_suppkey` int(11) NOT NULL COMMENT \"\",\n  `lo_orderpriority` varchar(100) NOT NULL COMMENT \"\",\n  `lo_shippriority` tinyint(4) NOT NULL COMMENT \"\",\n  `lo_quantity` tinyint(4) NOT NULL COMMENT \"\",\n  `lo_extendedprice` int(11) NOT NULL COMMENT \"\",\n  `lo_ordtotalprice` int(11) NOT NULL COMMENT \"\",\n  `lo_discount` tinyint(4) NOT NULL COMMENT \"\",\n  `lo_revenue` int(11) NOT NULL COMMENT \"\",\n  `lo_supplycost` int(11) NOT NULL COMMENT \"\",\n  `lo_tax` tinyint(4) NOT NULL COMMENT \"\",\n  `lo_commitdate` date NOT NULL COMMENT \"\",\n  `lo_shipmode` varchar(100) NOT NULL COMMENT \"\",\n  `c_name` varchar(100) NOT NULL COMMENT \"\",\n  `c_address` varchar(100) NOT NULL COMMENT \"\",\n  `c_city` varchar(100) NOT NULL COMMENT \"\",\n  `c_nation` varchar(100) NOT NULL COMMENT \"\",\n  `c_region` varchar(100) NOT NULL COMMENT \"\",\n  `c_phone` varchar(100) NOT NULL COMMENT \"\",\n  `c_mktsegment` varchar(100) NOT NULL COMMENT \"\",\n  `s_name` varchar(100) NOT NULL COMMENT \"\",\n  `s_address` varchar(100) NOT NULL COMMENT \"\",\n  `s_city` varchar(100) NOT NULL COMMENT \"\",\n  `s_nation` varchar(100) NOT NULL COMMENT \"\",\n  `s_region` varchar(100) NOT NULL COMMENT \"\",\n  `s_phone` varchar(100) NOT NULL COMMENT \"\",\n  `p_name` varchar(100) NOT NULL COMMENT \"\",\n  `p_mfgr` varchar(100) NOT NULL COMMENT \"\",\n  `p_category` varchar(100) NOT NULL COMMENT \"\",\n  `p_brand` varchar(100) NOT NULL COMMENT \"\",\n  `p_color` varchar(100) NOT NULL COMMENT \"\",\n  `p_type` varchar(100) NOT NULL COMMENT \"\",\n  `p_size` tinyint(4) NOT NULL COMMENT \"\",\n  `p_container` varchar(100) NOT NULL COMMENT \"\"\n) ENGINE=OLAP \nDUPLICATE KEY(`lo_orderdate`, `lo_orderkey`)\nCOMMENT \"olap\"\nPARTITION BY RANGE(`lo_orderdate`)\n(PARTITION p1 VALUES [(\"0000-01-01\"), (\"1993-01-01\")),\nPARTITION p2 VALUES [(\"1993-01-01\"), (\"1994-01-01\")),\nPARTITION p3 VALUES [(\"1994-01-01\"), (\"1995-01-01\")),\nPARTITION p4 VALUES [(\"1995-01-01\"), (\"1996-01-01\")),\nPARTITION p5 VALUES [(\"1996-01-01\"), (\"1997-01-01\")),\nPARTITION p6 VALUES [(\"1997-01-01\"), (\"1998-01-01\")),\nPARTITION p7 VALUES [(\"1998-01-01\"), (\"1999-01-01\")))\nDISTRIBUTED BY HASH(`lo_orderkey`) BUCKETS 48 \nPROPERTIES (\n\"replication_num\" = \"1\",\n\"colocate_with\" = \"groupxx1\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\",\n\"enable_persistent_index\" = \"false\",\n\"replicated_storage\" = \"false\",\n\"compression\" = \"LZ4\"\n);"},"table_row_count":{"ssb_100g.lineorder_flat":{"p1":91248844,"p2":91007488,"p3":91044214,"p4":91016436,"p5":91301792,"p6":91050840,"p7":53368288}},"session_variables":"{\"enable_show_all_variables\":true,\"cbo_cte_reuse\":true,\"full_sort_max_buffered_bytes\":16777216,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":false,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"cbo_cte_reuse_rate_v2\":1.15,\"transmission_encode_level\":7,\"character_set_results\":\"utf8\",\"transaction_isolation\":\"REPEATABLE-READ\",\"enable_global_runtime_filter\":true,\"load_transmission_compression_type\":\"NO_COMPRESSION\",\"cbo_enable_low_cardinality_optimize\":true,\"enable_resource_group_v2\":false,\"new_planner_optimize_timeout\":86400000,\"enable_outer_join_reorder\":true,\"enable_adaptive_sink_dop\":false,\"force_schedule_local\":false,\"hudi_mor_force_jni_reader\":false,\"full_sort_late_materialization\":false,\"enable_profile\":true,\"cbo_enable_greedy_join_reorder\":true,\"load_mem_limit\":0,\"sql_safe_updates\":0,\"enable_local_shuffle_agg\":true,\"cbo_debug_alive_backend_number\":0,\"global_runtime_filter_probe_min_size\":102400,\"nested_mv_rewrite_max_level\":3,\"query_delivery_timeout\":300,\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"broadcast_row_limit\":5000000,\"enable_populate_block_cache\":true,\"profile_limit_fold\":true,\"exec_mem_limit\":2147483648000,\"enable_sort_aggregate\":false,\"cbo_max_reorder_node_use_dp\":10,\"query_cache_force_populate\":false,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_rule_based_materialized_view_rewrite\":true,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"forward_to_leader\":false,\"count_distinct_column_buckets\":1024,\"full_sort_max_buffered_rows\":1024000,\"query_cache_agg_cardinality_limit\":5000000,\"query_timeout\":259200,\"enable_pipeline_query_statistic\":true,\"cbo_max_reorder_node\":50,\"cboPushDownAggregateMode_v1\":-1,\"window_partition_mode\":1,\"enable_deliver_batch_fragments\":true,\"enable_tablet_internal_parallel_v2\":false,\"enable_distinct_column_bucketization\":true,\"enable_big_query_log\":true,\"interpolate_passthrough\":true,\"enable_incremental_mv\":false,\"runtime_filter_scan_wait_time\":20,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"prefer_compute_node\":false,\"max_pipeline_dop\":64,\"activate_all_roles_on_login\":\"OFF\",\"broadcast_right_table_scale_factor\":10,\"group_concat_max_len\":65535,\"parse_tokens_limit\":3500000,\"chunk_size\":4096,\"runtime_join_filter_push_down_limit\":1024000,\"global_runtime_filter_probe_min_selectivity\":0.5,\"query_mem_limit\":0,\"enable_filter_unused_columns_in_scan_stage\":true,\"big_query_log_cpu_second_threshold\":480,\"enable_scan_block_cache\":false,\"div_precision_increment\":4,\"runtime_adaptive_dop_max_block_rows_per_driver_seq\":16384,\"auto_increment_increment\":1,\"sql_dialect\":\"StarRocks\",\"sql_mode_v2\":2,\"big_query_log_scan_rows_threshold\":1000000000,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":true,\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"enable_runtime_adaptive_dop\":false,\"cbo_cte_max_limit\":10,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"hive_partition_stats_sample_size\":3000,\"enable_optimizer_trace_log\":false,\"enable_mv_planner\":false,\"cbo_enable_dp_join_reorder\":true,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"profile_timeout\":2,\"pipeline_dop\":16,\"enable_query_dump\":false,\"single_node_exec_plan\":false,\"join_implementation_mode_v2\":\"auto\",\"global_runtime_filter_build_max_size\":67108864,\"sql_select_limit\":9223372036854775807,\"enable_materialized_view_rewrite\":true,\"statistic_collect_parallel\":1,\"enable_rewrite_sum_by_associative_rule\":true,\"query_cache_hot_partition_num\":3,\"enable_prune_complex_types\":true,\"query_cache_type\":0,\"disable_colocate_join\":false,\"query_cache_entry_max_rows\":409600,\"max_pushdown_conditions_per_column\":-1,\"default_table_compression\":\"lz4_frame\",\"enable_materialized_view_union_rewrite\":true,\"runtime_adaptive_dop_max_output_amplification_factor\":0,\"enable_exchange_pass_through\":true,\"query_cache_entry_max_bytes\":4194304,\"innodb_read_only\":true,\"cbo_reorder_threshold_use_exhaustive\":6,\"enable_exchange_perf\":false,\"enable_predicate_reorder\":false,\"workgroup_id\":0,\"enable_query_cache\":false,\"enable_rewrite_groupingsets_to_union_all\":false,\"transmission_compression_type\":\"LZ4\",\"interactive_timeout\":3600,\"max_allowed_packet\":1048576,\"big_query_log_scan_bytes_threshold\":10737418240,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"enable_multicolumn_global_runtime_filter\":false,\"character_set_server\":\"utf8\",\"tablet_internal_parallel_mode\":\"auto\",\"enable_pipeline\":true,\"cbo_use_nth_exec_plan\":0,\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"enable_query_debug_trace\":false,\"allow_default_partition\":false}","column_statistics":{"ssb_100g.lineorder_flat":{"lo_commitdate":"[6.967872E8, 9.097632E8, 0.0, 4.0, 2471.0] ESTIMATE","lo_orderkey":"[1.0, 6.0E8, 0.0, 4.0, 1.48064528E8] ESTIMATE","lo_extendedprice":"[90096.0, 1.049495E7, 0.0, 4.0, 1135983.0] ESTIMATE"}},"be_number":3,"be_core_stat":{"numOfHardwareCoresPerBe":"{\"10003\":16,\"10007\":16,\"10011\":16}","cachedAvgNumOfHardwareCores":16},"exception":[],"version":"UNKNOWN","commit_version":"2d750b9045"}